<test>

<substitutions>
    <substitution>
        <name>format</name>
        <values>
            <value>TabSeparated</value>
            <value>CSV</value>
            <value>Values</value>
            <value>JSONEachRow</value>
            <value>JSONCompactEachRow</value>
        </values>
    </substitution>
</substitutions>
    

<fill_query>INSERT INTO function file(data.{format}) SELECT WatchID, Title, EventTime, RefererCategories, RefererRegions FROM test.hits LIMIT 25000 SETTINGS engine_file_truncate_on_insert=1</fill_query>

<query>DESC file(data.{format}) SETTINGS schema_inference_use_cache_for_file=0</query>

<drop_query>INSERT INTO FUNCTION file(data.{format}) SELECT * FROM numbers(0) SETTINGS engine_file_truncate_on_insert=1</drop_query>

</test>
